/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此Model
 */
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using DGZImp.SysEntity;

namespace ATkg.BizAppProject.DomainModels
{
    [Entity(TableCnName = "三地计划汇总",TableName = "Plan_Summary_Three_Location",DetailTable =  new Type[] { typeof(Plan_Summary_Single_Location)},DetailTableCnName = "分厂详情",DBServer = "ServiceDbContext")]
    public partial class Plan_Summary_Three_Location:ServiceEntity
    {
        /// <summary>
       ///键
       /// </summary>
       [SugarColumn(IsPrimaryKey = true)]
       [Key]
       [Display(Name ="键")]
       [Column(TypeName="bigint")]
       [Required(AllowEmptyStrings=false)]
       public long Id { get; set; }

       /// <summary>
       ///产品代码
       /// </summary>
       [Display(Name ="产品代码")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string ProductId { get; set; }

       /// <summary>
       ///4周内成品需求数
       /// </summary>
       [Display(Name ="4周内成品需求数")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? RequirementIn4Week { get; set; }

       /// <summary>
       ///5-9周成品需求数
       /// </summary>
       [Display(Name ="5-9周成品需求数")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? RequirementIn5To9Week { get; set; }

       /// <summary>
       ///内部盘点-材料
       /// </summary>
       [Display(Name ="内部盘点-材料")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? InventoryMaterial { get; set; }

       /// <summary>
       ///内部盘点-毛坯
       /// </summary>
       [Display(Name ="内部盘点-毛坯")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? InventoryBlank { get; set; }

       /// <summary>
       ///内部盘点-加工-检验
       /// </summary>
       [Display(Name ="内部盘点-加工-检验")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? InventoryProcessCheck { get; set; }

       /// <summary>
       ///内部盘点-成品
       /// </summary>
       [Display(Name ="内部盘点-成品")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? InventoryFinal { get; set; }

       /// <summary>
       ///成品OEM订单未完成数量
       /// </summary>
       [Display(Name ="成品OEM订单未完成数量")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? UnfinishedFinalOEM { get; set; }

       /// <summary>
       ///成品34周交付计划
       /// </summary>
       [Display(Name ="成品34周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan34Week { get; set; }

       /// <summary>
       ///成品35周交付计划
       /// </summary>
       [Display(Name ="成品35周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan35Week { get; set; }

       /// <summary>
       ///成品36周交付计划
       /// </summary>
       [Display(Name ="成品36周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan36Week { get; set; }

       /// <summary>
       ///成品37周交付计划
       /// </summary>
       [Display(Name ="成品37周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan37Week { get; set; }

       /// <summary>
       ///成品38周交付计划
       /// </summary>
       [Display(Name ="成品38周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan38Week { get; set; }

       /// <summary>
       ///成品39周交付计划
       /// </summary>
       [Display(Name ="成品39周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan39Week { get; set; }

       /// <summary>
       ///成品40周交付计划
       /// </summary>
       [Display(Name ="成品40周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan40Week { get; set; }

       /// <summary>
       ///成品41周交付计划
       /// </summary>
       [Display(Name ="成品41周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan41Week { get; set; }

       /// <summary>
       ///成品42周交付计划
       /// </summary>
       [Display(Name ="成品42周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan42Week { get; set; }

       /// <summary>
       ///成品43周交付计划
       /// </summary>
       [Display(Name ="成品43周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan43Week { get; set; }

       /// <summary>
       ///成品44周交付计划
       /// </summary>
       [Display(Name ="成品44周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan44Week { get; set; }

       /// <summary>
       ///成品45周交付计划
       /// </summary>
       [Display(Name ="成品45周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan45Week { get; set; }

       /// <summary>
       ///成品46周交付计划
       /// </summary>
       [Display(Name ="成品46周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan46Week { get; set; }

       /// <summary>
       ///成品47周交付计划
       /// </summary>
       [Display(Name ="成品47周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan47Week { get; set; }

       /// <summary>
       ///成品48周交付计划
       /// </summary>
       [Display(Name ="成品48周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan48Week { get; set; }

       /// <summary>
       ///成品49周交付计划
       /// </summary>
       [Display(Name ="成品49周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan49Week { get; set; }

       /// <summary>
       ///成品50周交付计划
       /// </summary>
       [Display(Name ="成品50周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan50Week { get; set; }

       /// <summary>
       ///毛坯OEM订单未完成数量
       /// </summary>
       [Display(Name ="毛坯OEM订单未完成数量")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? UnfinishedBlankOEM { get; set; }

       /// <summary>
       ///毛坯34周交付计划
       /// </summary>
       [Display(Name ="毛坯34周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan34Week { get; set; }

       /// <summary>
       ///毛坯35周交付计划
       /// </summary>
       [Display(Name ="毛坯35周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan35Week { get; set; }

       /// <summary>
       ///毛坯36周交付计划
       /// </summary>
       [Display(Name ="毛坯36周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan36Week { get; set; }

       /// <summary>
       ///毛坯37周交付计划
       /// </summary>
       [Display(Name ="毛坯37周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan37Week { get; set; }

       /// <summary>
       ///毛坯38周交付计划
       /// </summary>
       [Display(Name ="毛坯38周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan38Week { get; set; }

       /// <summary>
       ///毛坯39周交付计划
       /// </summary>
       [Display(Name ="毛坯39周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan39Week { get; set; }

       /// <summary>
       ///毛坯40周交付计划
       /// </summary>
       [Display(Name ="毛坯40周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan40Week { get; set; }

       /// <summary>
       ///毛坯41周交付计划
       /// </summary>
       [Display(Name ="毛坯41周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan41Week { get; set; }

       /// <summary>
       ///毛坯42周交付计划
       /// </summary>
       [Display(Name ="毛坯42周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan42Week { get; set; }

       /// <summary>
       ///毛坯43周交付计划
       /// </summary>
       [Display(Name ="毛坯43周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan43Week { get; set; }

       /// <summary>
       ///毛坯44周交付计划
       /// </summary>
       [Display(Name ="毛坯44周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan44Week { get; set; }

       /// <summary>
       ///毛坯45周交付计划
       /// </summary>
       [Display(Name ="毛坯45周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan45Week { get; set; }

       /// <summary>
       ///毛坯46周交付计划
       /// </summary>
       [Display(Name ="毛坯46周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan46Week { get; set; }

       /// <summary>
       ///毛坯47周交付计划
       /// </summary>
       [Display(Name ="毛坯47周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan47Week { get; set; }

       /// <summary>
       ///毛坯48周交付计划
       /// </summary>
       [Display(Name ="毛坯48周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan48Week { get; set; }

       /// <summary>
       ///毛坯49周交付计划
       /// </summary>
       [Display(Name ="毛坯49周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan49Week { get; set; }

       /// <summary>
       ///毛坯50周交付计划
       /// </summary>
       [Display(Name ="毛坯50周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan50Week { get; set; }

       /// <summary>
       ///是否有效(0:否,1:是)
       /// </summary>
       [Display(Name ="是否有效(0:否,1:是)")]
       [Column(TypeName="int")]
       [Required(AllowEmptyStrings=false)]
       public int IsValid { get; set; }

       /// <summary>
       ///备注
       /// </summary>
       [Display(Name ="备注")]
       [Column(TypeName="nvarchar(max)")]
       public string Remarks { get; set; }

       /// <summary>
       ///创建人ID
       /// </summary>
       [Display(Name ="创建人ID")]
       [Column(TypeName="bigint")]
       [Required(AllowEmptyStrings=false)]
       public long CreateId { get; set; }

       /// <summary>
       ///创建人名
       /// </summary>
       [Display(Name ="创建人名")]
       [MaxLength(50)]
       [Column(TypeName="nvarchar(50)")]
       public string Creator { get; set; }

       /// <summary>
       ///创建时间
       /// </summary>
       [Display(Name ="创建时间")]
       [Column(TypeName="datetime")]
       public DateTime? CreateTime { get; set; }

       /// <summary>
       ///修改人ID
       /// </summary>
       [Display(Name ="修改人ID")]
       [Column(TypeName="bigint")]
       public long? ModifyId { get; set; }

       /// <summary>
       ///修改人名
       /// </summary>
       [Display(Name ="修改人名")]
       [MaxLength(30)]
       [Column(TypeName="nvarchar(30)")]
       public string Modifier { get; set; }

       /// <summary>
       ///修改时间
       /// </summary>
       [Display(Name ="修改时间")]
       [Column(TypeName="datetime")]
       public DateTime? ModifyTime { get; set; }

       /// <summary>
       ///成品51周交付计划
       /// </summary>
       [Display(Name ="成品51周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan51Week { get; set; }

       /// <summary>
       ///成品52周交付计划
       /// </summary>
       [Display(Name ="成品52周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan52Week { get; set; }

       /// <summary>
       ///成品53周交付计划
       /// </summary>
       [Display(Name ="成品53周交付计划")]
       [DisplayFormat(DataFormatString="64,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? FianlPlan53Week { get; set; }

       /// <summary>
       ///毛坯51周交付计划
       /// </summary>
       [Display(Name ="毛坯51周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan51Week { get; set; }

       /// <summary>
       ///毛坯52周交付计划
       /// </summary>
       [Display(Name ="毛坯52周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan52Week { get; set; }

       /// <summary>
       ///毛坯53周交付计划
       /// </summary>
       [Display(Name ="毛坯53周交付计划")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? BlankPlan53Week { get; set; }

       [Display(Name ="分厂详情")]
       [ForeignKey("Id")][Navigate(NavigateType.OneToMany,nameof(Id),nameof(Id))]
       public List<Plan_Summary_Single_Location> Plan_Summary_Single_Location { get; set; }


       
    }
}